SELECT * FROM T_UWWTPS WHERE uwwState=1 AND uwwCode NOT IN (SELECT aucUwwCode FROM T_UWWTPAgglos)

---